﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="DataSet1" targetNamespace="http://tempuri.org/DataSet1.xsd" xmlns:mstns="http://tempuri.org/DataSet1.xsd" xmlns="http://tempuri.org/DataSet1.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="3" FunctionsComponentName="Generic_Data_Cheker" GeneratorFunctionsComponentClassName="Generic_Data_Cheker" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" UserFunctionsComponentName="Generic_Data_Cheker" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="UCC_IS_PRE_PRODConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="UCC_IS_PRE_PRODConnectionString (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.UCC_IS_PRE_PRODConnectionString.ConnectionString" Provider="System.Data.SqlClient" />
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="bestgifts4usConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="bestgifts4usConnectionString (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.bestgifts4usConnectionString.ConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="usersTableAdapter" GeneratorDataComponentClassName="usersTableAdapter" Name="users" UserDataComponentName="usersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="bestgifts4usConnectionString (Web.config)" DbObjectName="[UCC-IS-PRE-PROD].dbo.users" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[users] WHERE (([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO users
                         (username, password, email, address, town, country, firstname, lastname, userstatus)
VALUES        (@username,@password,@email,@address,@town,@country,@firstname,@lastname,@userstatus);
select </CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="username" ColumnName="username" DataSourceName="[UCC-IS-PRE-PROD].dbo.users" DataTypeServer="nchar(100)" DbType="String" Direction="Input" ParameterName="@username" Precision="0" ProviderType="NChar" Scale="0" Size="100" SourceColumn="username" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="password" ColumnName="password" DataSourceName="[UCC-IS-PRE-PROD].dbo.users" DataTypeServer="nchar(100)" DbType="String" Direction="Input" ParameterName="@password" Precision="0" ProviderType="NChar" Scale="0" Size="100" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="email" ColumnName="email" DataSourceName="[UCC-IS-PRE-PROD].dbo.users" DataTypeServer="nchar(100)" DbType="String" Direction="Input" ParameterName="@email" Precision="0" ProviderType="NChar" Scale="0" Size="100" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="address" ColumnName="address" DataSourceName="[UCC-IS-PRE-PROD].dbo.users" DataTypeServer="nchar(100)" DbType="String" Direction="Input" ParameterName="@address" Precision="0" ProviderType="NChar" Scale="0" Size="100" SourceColumn="address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="town" ColumnName="town" DataSourceName="[UCC-IS-PRE-PROD].dbo.users" DataTypeServer="nchar(100)" DbType="String" Direction="Input" ParameterName="@town" Precision="0" ProviderType="NChar" Scale="0" Size="100" SourceColumn="town" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="country" ColumnName="country" DataSourceName="[UCC-IS-PRE-PROD].dbo.users" DataTypeServer="nchar(100)" DbType="String" Direction="Input" ParameterName="@country" Precision="0" ProviderType="NChar" Scale="0" Size="100" SourceColumn="country" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="firstname" ColumnName="firstname" DataSourceName="[UCC-IS-PRE-PROD].dbo.users" DataTypeServer="nchar(100)" DbType="String" Direction="Input" ParameterName="@firstname" Precision="0" ProviderType="NChar" Scale="0" Size="100" SourceColumn="firstname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="lastname" ColumnName="lastname" DataSourceName="[UCC-IS-PRE-PROD].dbo.users" DataTypeServer="nchar(100)" DbType="String" Direction="Input" ParameterName="@lastname" Precision="0" ProviderType="NChar" Scale="0" Size="100" SourceColumn="lastname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="userstatus" ColumnName="userstatus" DataSourceName="[UCC-IS-PRE-PROD].dbo.users" DataTypeServer="nchar(100)" DbType="String" Direction="Input" ParameterName="@userstatus" Precision="0" ProviderType="NChar" Scale="0" Size="100" SourceColumn="userstatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT id, username, password, email, address, town, country, firstname, lastname, userstatus FROM dbo.users</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[users] SET [username] = @username, [password] = @password, [email] = @email, [address] = @address, [town] = @town, [country] = @country, [firstname] = @firstname, [lastname] = @lastname, [userstatus] = @userstatus WHERE (([id] = @Original_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@username" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="username" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@password" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@email" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@address" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="address" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@town" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="town" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@country" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="country" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@firstname" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="firstname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@lastname" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="lastname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@userstatus" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="userstatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="id" DataSetColumn="id" />
              <Mapping SourceColumn="username" DataSetColumn="username" />
              <Mapping SourceColumn="password" DataSetColumn="password" />
              <Mapping SourceColumn="email" DataSetColumn="email" />
              <Mapping SourceColumn="address" DataSetColumn="address" />
              <Mapping SourceColumn="town" DataSetColumn="town" />
              <Mapping SourceColumn="country" DataSetColumn="country" />
              <Mapping SourceColumn="firstname" DataSetColumn="firstname" />
              <Mapping SourceColumn="lastname" DataSetColumn="lastname" />
              <Mapping SourceColumn="userstatus" DataSetColumn="userstatus" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="fb_usersTableAdapter" GeneratorDataComponentClassName="fb_usersTableAdapter" Name="fb_users" UserDataComponentName="fb_usersTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="UCC_IS_PRE_PRODConnectionString (Web.config)" DbObjectName="[UCC-IS-PRE-PROD].dbo.fb_users" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[fb_users] WHERE (([fb_id] = @Original_fb_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_fb_id" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="fb_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[fb_users] ([fb_id], [user_id], [fb_user_name]) VALUES (@fb_id, @user_id, @fb_user_name)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@fb_id" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="fb_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@user_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="user_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@fb_user_name" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="fb_user_name" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT fb_id, user_id, fb_user_name FROM dbo.fb_users</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[fb_users] SET [fb_id] = @fb_id, [user_id] = @user_id, [fb_user_name] = @fb_user_name WHERE (([fb_id] = @Original_fb_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@fb_id" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="fb_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@user_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="user_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@fb_user_name" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="fb_user_name" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@Original_fb_id" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="fb_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="fb_id" DataSetColumn="fb_id" />
              <Mapping SourceColumn="user_id" DataSetColumn="user_id" />
              <Mapping SourceColumn="fb_user_name" DataSetColumn="fb_user_name" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="wishlistsTableAdapter" GeneratorDataComponentClassName="wishlistsTableAdapter" Name="wishlists" UserDataComponentName="wishlistsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="bestgifts4usConnectionString (Web.config)" DbObjectName="ess_prod_test.dbo.wishlists" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[wishlists] WHERE (([wishlist_id] = @Original_wishlist_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_wishlist_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="wishlist_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[wishlists] ([created], [wishlistname], [wishlist_cat_id]) VALUES (@created, @wishlistname, @wishlist_cat_id);
SELECT wishlist_id, created, wishlistname, wishlist_cat_id FROM wishlists WHERE (wishlist_id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@created" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="created" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@wishlistname" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="wishlistname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@wishlist_cat_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="wishlist_cat_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT wishlist_id, created, wishlistname, wishlist_cat_id FROM dbo.wishlists</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[wishlists] SET [created] = @created, [wishlistname] = @wishlistname, [wishlist_cat_id] = @wishlist_cat_id WHERE (([wishlist_id] = @Original_wishlist_id));
SELECT wishlist_id, created, wishlistname, wishlist_cat_id FROM wishlists WHERE (wishlist_id = @wishlist_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@created" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="created" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="StringFixedLength" Direction="Input" ParameterName="@wishlistname" Precision="0" ProviderType="NChar" Scale="0" Size="0" SourceColumn="wishlistname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@wishlist_cat_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="wishlist_cat_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_wishlist_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="wishlist_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="wishlist_id" ColumnName="wishlist_id" DataSourceName="ess_prod_test.dbo.wishlists" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@wishlist_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="wishlist_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="wishlist_id" DataSetColumn="wishlist_id" />
              <Mapping SourceColumn="created" DataSetColumn="created" />
              <Mapping SourceColumn="wishlistname" DataSetColumn="wishlistname" />
              <Mapping SourceColumn="wishlist_cat_id" DataSetColumn="wishlist_cat_id" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="bestgifts4usConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="InsertQuery" Modifier="Public" Name="InsertQuery" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="InsertQuery">
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>INSERT INTO [dbo].[wishlists] ([created], [wishlistname], [wishlist_cat_id]) VALUES (@created, @wishlistname, @wishlist_cat_id);
SELECT wishlist_id, created, wishlistname, wishlist_cat_id FROM wishlists WHERE (wishlist_id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="created" ColumnName="created" DataSourceName="ess_prod_test.dbo.wishlists" DataTypeServer="date" DbType="DateTime" Direction="Input" ParameterName="@created" Precision="0" ProviderType="DateTime" Scale="0" Size="3" SourceColumn="created" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="wishlistname" ColumnName="wishlistname" DataSourceName="ess_prod_test.dbo.wishlists" DataTypeServer="nchar(1000)" DbType="String" Direction="Input" ParameterName="@wishlistname" Precision="0" ProviderType="NChar" Scale="0" Size="1000" SourceColumn="wishlistname" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="wishlist_cat_id" ColumnName="wishlist_cat_id" DataSourceName="ess_prod_test.dbo.wishlists" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@wishlist_cat_id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="wishlist_cat_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="user_whishlistTableAdapter" GeneratorDataComponentClassName="user_whishlistTableAdapter" Name="user_whishlist" UserDataComponentName="user_whishlistTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="bestgifts4usConnectionString (Web.config)" DbObjectName="ess_prod_test.dbo.user_whishlist" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[user_whishlist] WHERE (([rec_id] = @Original_rec_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_rec_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="rec_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[user_whishlist] ([user_id], [wishlist_id]) VALUES (@user_id, @wishlist_id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@user_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="user_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@wishlist_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="wishlist_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT rec_id, user_id, wishlist_id FROM dbo.user_whishlist</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[user_whishlist] SET [user_id] = @user_id, [wishlist_id] = @wishlist_id WHERE (([rec_id] = @Original_rec_id))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@user_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="user_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@wishlist_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="wishlist_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_rec_id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="rec_id" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="rec_id" DataSetColumn="rec_id" />
              <Mapping SourceColumn="user_id" DataSetColumn="user_id" />
              <Mapping SourceColumn="wishlist_id" DataSetColumn="wishlist_id" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources>
          <DbSource ConnectionRef="bestgifts4usConnectionString (Web.config)" DbObjectName="[UCC-IS-PRE-PROD].dbo.fb_users" DbObjectType="Table" GenerateShortCommands="true" GeneratorSourceName="GetFBUser" MethodsParameterType="CLR" Modifier="Public" Name="GetFBUser" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="GetFBUser">
            <SelectCommand>
              <DbCommand CommandType="Text" ModifiedByUser="true">
                <CommandText>SELECT        user_id
FROM            fb_users
WHERE        (fb_id = @fb_id)</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="false" AutogeneratedName="fb_id" ColumnName="fb_id" DataSourceName="[UCC-IS-PRE-PROD].dbo.fb_users" DataTypeServer="nchar(100)" DbType="String" Direction="Input" ParameterName="@fb_id" Precision="0" ProviderType="NChar" Scale="0" Size="100" SourceColumn="fb_id" SourceColumnNullMapping="false" SourceVersion="Current" />
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
          <DbSource ConnectionRef="bestgifts4usConnectionString (Web.config)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="true" GeneratorSourceName="UserIDIdentity" MethodsParameterType="CLR" Modifier="Public" Name="UserIDIdentity" QueryType="Scalar" ScalarCallRetval="System.Decimal, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy1" UserSourceName="UserIDIdentity">
            <SelectCommand>
              <DbCommand CommandType="Text" ModifiedByUser="true">
                <CommandText>INSERT INTO users
                         (username, password, email, address, town, country, firstname, lastname, userstatus)
VALUES        (@username,@password,@email,@address,@town,@country,@firstname,@lastname,@userstatus);

SELECT        SCOPE_IDENTITY() AS Expr1</CommandText>
                <Parameters>
                  <Parameter AllowDbNull="true" AutogeneratedName="username" ColumnName="username" DataSourceName="[UCC-IS-PRE-PROD].dbo.users" DataTypeServer="nchar(100)" DbType="String" Direction="Input" ParameterName="@username" Precision="0" ProviderType="NChar" Scale="0" Size="100" SourceColumn="username" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="password" ColumnName="password" DataSourceName="[UCC-IS-PRE-PROD].dbo.users" DataTypeServer="nchar(100)" DbType="String" Direction="Input" ParameterName="@password" Precision="0" ProviderType="NChar" Scale="0" Size="100" SourceColumn="password" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="email" ColumnName="email" DataSourceName="[UCC-IS-PRE-PROD].dbo.users" DataTypeServer="nchar(100)" DbType="String" Direction="Input" ParameterName="@email" Precision="0" ProviderType="NChar" Scale="0" Size="100" SourceColumn="email" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="address" ColumnName="address" DataSourceName="[UCC-IS-PRE-PROD].dbo.users" DataTypeServer="nchar(100)" DbType="String" Direction="Input" ParameterName="@address" Precision="0" ProviderType="NChar" Scale="0" Size="100" SourceColumn="address" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="town" ColumnName="town" DataSourceName="[UCC-IS-PRE-PROD].dbo.users" DataTypeServer="nchar(100)" DbType="String" Direction="Input" ParameterName="@town" Precision="0" ProviderType="NChar" Scale="0" Size="100" SourceColumn="town" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="country" ColumnName="country" DataSourceName="[UCC-IS-PRE-PROD].dbo.users" DataTypeServer="nchar(100)" DbType="String" Direction="Input" ParameterName="@country" Precision="0" ProviderType="NChar" Scale="0" Size="100" SourceColumn="country" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="firstname" ColumnName="firstname" DataSourceName="[UCC-IS-PRE-PROD].dbo.users" DataTypeServer="nchar(100)" DbType="String" Direction="Input" ParameterName="@firstname" Precision="0" ProviderType="NChar" Scale="0" Size="100" SourceColumn="firstname" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="true" AutogeneratedName="lastname" ColumnName="lastname" DataSourceName="[UCC-IS-PRE-PROD].dbo.users" DataTypeServer="nchar(100)" DbType="String" Direction="Input" ParameterName="@lastname" Precision="0" ProviderType="NChar" Scale="0" Size="100" SourceColumn="lastname" SourceColumnNullMapping="false" SourceVersion="Current" />
                  <Parameter AllowDbNull="false" AutogeneratedName="userstatus" ColumnName="userstatus" DataSourceName="[UCC-IS-PRE-PROD].dbo.users" DataTypeServer="nchar(100)" DbType="String" Direction="Input" ParameterName="@userstatus" Precision="0" ProviderType="NChar" Scale="0" Size="100" SourceColumn="userstatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                </Parameters>
              </DbCommand>
            </SelectCommand>
          </DbSource>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="DataSet1" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="DataSet1" msprop:Generator_UserDSName="DataSet1">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="users" msprop:Generator_TableClassName="usersDataTable" msprop:Generator_TableVarName="tableusers" msprop:Generator_TablePropName="users" msprop:Generator_RowDeletingName="usersRowDeleting" msprop:Generator_UserTableName="users" msprop:Generator_RowChangingName="usersRowChanging" msprop:Generator_RowEvHandlerName="usersRowChangeEventHandler" msprop:Generator_RowDeletedName="usersRowDeleted" msprop:Generator_RowEvArgName="usersRowChangeEvent" msprop:Generator_RowChangedName="usersRowChanged" msprop:Generator_RowClassName="usersRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnid" msprop:Generator_ColumnPropNameInRow="id" msprop:Generator_ColumnPropNameInTable="idColumn" msprop:Generator_UserColumnName="id" type="xs:int" />
              <xs:element name="username" msprop:Generator_ColumnVarNameInTable="columnusername" msprop:Generator_ColumnPropNameInRow="username" msprop:Generator_ColumnPropNameInTable="usernameColumn" msprop:Generator_UserColumnName="username" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="password" msprop:Generator_ColumnVarNameInTable="columnpassword" msprop:Generator_ColumnPropNameInRow="password" msprop:Generator_ColumnPropNameInTable="passwordColumn" msprop:Generator_UserColumnName="password" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="email" msprop:Generator_ColumnVarNameInTable="columnemail" msprop:Generator_ColumnPropNameInRow="email" msprop:Generator_ColumnPropNameInTable="emailColumn" msprop:Generator_UserColumnName="email" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="address" msprop:Generator_ColumnVarNameInTable="columnaddress" msprop:Generator_ColumnPropNameInRow="address" msprop:Generator_ColumnPropNameInTable="addressColumn" msprop:Generator_UserColumnName="address" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="town" msprop:Generator_ColumnVarNameInTable="columntown" msprop:Generator_ColumnPropNameInRow="town" msprop:Generator_ColumnPropNameInTable="townColumn" msprop:Generator_UserColumnName="town" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="country" msprop:Generator_ColumnVarNameInTable="columncountry" msprop:Generator_ColumnPropNameInRow="country" msprop:Generator_ColumnPropNameInTable="countryColumn" msprop:Generator_UserColumnName="country" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="firstname" msprop:Generator_ColumnVarNameInTable="columnfirstname" msprop:Generator_ColumnPropNameInRow="firstname" msprop:Generator_ColumnPropNameInTable="firstnameColumn" msprop:Generator_UserColumnName="firstname" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="lastname" msprop:Generator_ColumnVarNameInTable="columnlastname" msprop:Generator_ColumnPropNameInRow="lastname" msprop:Generator_ColumnPropNameInTable="lastnameColumn" msprop:Generator_UserColumnName="lastname" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="userstatus" msprop:Generator_ColumnVarNameInTable="columnuserstatus" msprop:Generator_ColumnPropNameInRow="userstatus" msprop:Generator_ColumnPropNameInTable="userstatusColumn" msprop:Generator_UserColumnName="userstatus">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="fb_users" msprop:Generator_TableClassName="fb_usersDataTable" msprop:Generator_TableVarName="tablefb_users" msprop:Generator_TablePropName="fb_users" msprop:Generator_RowDeletingName="fb_usersRowDeleting" msprop:Generator_UserTableName="fb_users" msprop:Generator_RowChangingName="fb_usersRowChanging" msprop:Generator_RowEvHandlerName="fb_usersRowChangeEventHandler" msprop:Generator_RowDeletedName="fb_usersRowDeleted" msprop:Generator_RowEvArgName="fb_usersRowChangeEvent" msprop:Generator_RowChangedName="fb_usersRowChanged" msprop:Generator_RowClassName="fb_usersRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="fb_id" msprop:Generator_ColumnVarNameInTable="columnfb_id" msprop:Generator_ColumnPropNameInRow="fb_id" msprop:Generator_ColumnPropNameInTable="fb_idColumn" msprop:Generator_UserColumnName="fb_id">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="user_id" msprop:Generator_ColumnVarNameInTable="columnuser_id" msprop:Generator_ColumnPropNameInRow="user_id" msprop:Generator_ColumnPropNameInTable="user_idColumn" msprop:Generator_UserColumnName="user_id" type="xs:int" minOccurs="0" />
              <xs:element name="fb_user_name" msprop:Generator_ColumnVarNameInTable="columnfb_user_name" msprop:Generator_ColumnPropNameInRow="fb_user_name" msprop:Generator_ColumnPropNameInTable="fb_user_nameColumn" msprop:Generator_UserColumnName="fb_user_name" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="wishlists" msprop:Generator_TableClassName="wishlistsDataTable" msprop:Generator_TableVarName="tablewishlists" msprop:Generator_TablePropName="wishlists" msprop:Generator_RowDeletingName="wishlistsRowDeleting" msprop:Generator_UserTableName="wishlists" msprop:Generator_RowChangingName="wishlistsRowChanging" msprop:Generator_RowEvHandlerName="wishlistsRowChangeEventHandler" msprop:Generator_RowDeletedName="wishlistsRowDeleted" msprop:Generator_RowEvArgName="wishlistsRowChangeEvent" msprop:Generator_RowChangedName="wishlistsRowChanged" msprop:Generator_RowClassName="wishlistsRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="wishlist_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnwishlist_id" msprop:Generator_ColumnPropNameInRow="wishlist_id" msprop:Generator_ColumnPropNameInTable="wishlist_idColumn" msprop:Generator_UserColumnName="wishlist_id" type="xs:int" />
              <xs:element name="created" msprop:Generator_ColumnVarNameInTable="columncreated" msprop:Generator_ColumnPropNameInRow="created" msprop:Generator_ColumnPropNameInTable="createdColumn" msprop:Generator_UserColumnName="created" type="xs:dateTime" />
              <xs:element name="wishlistname" msprop:Generator_ColumnVarNameInTable="columnwishlistname" msprop:Generator_ColumnPropNameInRow="wishlistname" msprop:Generator_ColumnPropNameInTable="wishlistnameColumn" msprop:Generator_UserColumnName="wishlistname" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="wishlist_cat_id" msprop:Generator_ColumnVarNameInTable="columnwishlist_cat_id" msprop:Generator_ColumnPropNameInRow="wishlist_cat_id" msprop:Generator_ColumnPropNameInTable="wishlist_cat_idColumn" msprop:Generator_UserColumnName="wishlist_cat_id" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="user_whishlist" msprop:Generator_TableClassName="user_whishlistDataTable" msprop:Generator_TableVarName="tableuser_whishlist" msprop:Generator_TablePropName="user_whishlist" msprop:Generator_RowDeletingName="user_whishlistRowDeleting" msprop:Generator_UserTableName="user_whishlist" msprop:Generator_RowChangingName="user_whishlistRowChanging" msprop:Generator_RowEvHandlerName="user_whishlistRowChangeEventHandler" msprop:Generator_RowDeletedName="user_whishlistRowDeleted" msprop:Generator_RowEvArgName="user_whishlistRowChangeEvent" msprop:Generator_RowChangedName="user_whishlistRowChanged" msprop:Generator_RowClassName="user_whishlistRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="rec_id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnrec_id" msprop:Generator_ColumnPropNameInRow="rec_id" msprop:Generator_ColumnPropNameInTable="rec_idColumn" msprop:Generator_UserColumnName="rec_id" type="xs:int" />
              <xs:element name="user_id" msprop:Generator_ColumnVarNameInTable="columnuser_id" msprop:Generator_ColumnPropNameInRow="user_id" msprop:Generator_ColumnPropNameInTable="user_idColumn" msprop:Generator_UserColumnName="user_id" type="xs:int" minOccurs="0" />
              <xs:element name="wishlist_id" msprop:Generator_ColumnVarNameInTable="columnwishlist_id" msprop:Generator_ColumnPropNameInRow="wishlist_id" msprop:Generator_ColumnPropNameInTable="wishlist_idColumn" msprop:Generator_UserColumnName="wishlist_id" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:users" />
      <xs:field xpath="mstns:id" />
    </xs:unique>
    <xs:unique name="fb_users_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:fb_users" />
      <xs:field xpath="mstns:fb_id" />
    </xs:unique>
    <xs:unique name="wishlists_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:wishlists" />
      <xs:field xpath="mstns:wishlist_id" />
    </xs:unique>
    <xs:unique name="user_whishlist_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:user_whishlist" />
      <xs:field xpath="mstns:rec_id" />
    </xs:unique>
  </xs:element>
</xs:schema>